Modifying a Directory Entry
You can update all of the information in directory entries except for the Directory entry name.
To modify the details of a Directory Entry, type 1 in the Opt column for the entry on the Work with DB Directory Entries screen (STRDB > 1) and press Enter. The Modify Directory Entry screen appears:
| Modify Directory Entry - Part A Directory entry . . . . . . FB Active: N (Driver: FIREBIRD ) Description . . . . . . . . Firebird sample database Log . . . . . . . . . . . . 0 0=Dft, 1=None, 2=Basic, 4=All Host or IP . . . . .<host> 1.1.1.35 Port . . . . . . . .<port> 3050 Catalog . . . . . <catalog> Schema . . . . . .<schema> Database . . . . . . .<db> file . . . . . . . .<adl1> EMPLOYEE URL, file://, http://... . jdbc:firebirdsql://<host>:<port>/<adl1> Auto replacments are: <host><port><catalog> <schema><db><adl1-4> More... F3=Exit F4=Prompt F7=Driver page F8=Replace driver F12=Cancel |
The screen consists of two pages. Press the PgDn key to use the second page.
| Modify Directory Entry - Part B Directory entry . . . . . . BIG (Driver: BIG_SQL ) Description . . . . . . . . IBM Big Data Language support . . . . . *AUTO *AUTO, *NONE, 4-11 for Bidi Keep alive interval . . . . 0 Minutes, 0=No Keep alive statement . . . Fetch size . . . . . . . . 0 Number of records, 0=Default User for URL. . . . .<user> *NONE Password . .<password> The following overrides CONNECT / Server Authentication Entry values. Force RDB User . . . . . . *NONE Name, *NONE Password . . . . Character (case sensitive) Bottom F3=Exit F12=Cancel |
The screens contain these fields. Some of the parameters may vary depending on the selected driver.
Directory Entry
Name of the directory (Read-only)
Active
Y (yes) or N (no).
NOTE: Active entries are registered within the system and are counted per the license.
Driver
The driver you associated with the new entry
Description
Description of the directory (optional)
Log
0: Global default (from System Configuration’s General Definitions screen)
1: No log (no data is stored)
2: Connect (the log will store a record of each connection and disconnection from a database)
4: All (the log will store all commands sent; when a Fetch command is sent, it will only store the first in the series)
Host or IP
The address used to access the remote database
Port
The port number associated with the above address required for setting up a connection to the remote database
Catalog
If the database requires a Catalog for the connection, specify it here
Schema
The schema for the remote database
Database
Database name
Additional parameters:
Up to four different parameters, based on the selected driver.
URL
Provided by the DB driver provider. May include parameters:
<host><ip><user><pwd><catalog><port><schema><adl1-4>
If an empty Password is received when connecting, DB- Gate also ignores the User field and attempts to create a connection based on the JDBC URL, which points to am IBM i server in which the data imported from PC files will be stored (as shown in Appendix A: JDBC Driver for Excel, CSV, etc.).
Language Support
Specifies whether the entry supports other languages. This is used, for example, for bi-directional data that mixes Hebrew or Arabic with English.
*AUTO : Default setting
*NONE
4-11 : Based on an IBM setting for specific language support.
Keep alive interval
Frequency with which the keep alive SQL statement is sent to DB to ensure that the connection is maintained.
Keep alive statement
SQL statement sent to DB to ensure connection is maintained.
Fetch size
The number of records to bring when writing SQL statements.
The larger the number, the fewer accesses to the disk but also longer waiting time.
F8 Replace Driver
Enables users to replace the driver configuration for this RDB entry